{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "# 读取 Excel 文件\n",
    "df = pd.read_excel('./data/中国各城市空间权重矩阵(1).xlsx', sheet_name='地理距离矩阵')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>proveng</th>\n",
       "      <th>cityeng</th>\n",
       "      <th>cityseries</th>\n",
       "      <th>city1</th>\n",
       "      <th>city2</th>\n",
       "      <th>city3</th>\n",
       "      <th>city9</th>\n",
       "      <th>city12</th>\n",
       "      <th>city13</th>\n",
       "      <th>city15</th>\n",
       "      <th>...</th>\n",
       "      <th>City590</th>\n",
       "      <th>City591</th>\n",
       "      <th>City592</th>\n",
       "      <th>City595</th>\n",
       "      <th>City597</th>\n",
       "      <th>City600</th>\n",
       "      <th>City601</th>\n",
       "      <th>City602</th>\n",
       "      <th>City604</th>\n",
       "      <th>City605</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Beijing</td>\n",
       "      <td>Beijing</td>\n",
       "      <td>City1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>96.06</td>\n",
       "      <td>239.46</td>\n",
       "      <td>162.11</td>\n",
       "      <td>266.93</td>\n",
       "      <td>394.54</td>\n",
       "      <td>326.77</td>\n",
       "      <td>...</td>\n",
       "      <td>1383.90</td>\n",
       "      <td>988.22</td>\n",
       "      <td>1537.70</td>\n",
       "      <td>903.66</td>\n",
       "      <td>1340.78</td>\n",
       "      <td>884.18</td>\n",
       "      <td>864.88</td>\n",
       "      <td>907.68</td>\n",
       "      <td>2433.90</td>\n",
       "      <td>2666.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Tianjin</td>\n",
       "      <td>Tianjin</td>\n",
       "      <td>City2</td>\n",
       "      <td>96.06</td>\n",
       "      <td>0.00</td>\n",
       "      <td>269.63</td>\n",
       "      <td>93.42</td>\n",
       "      <td>200.99</td>\n",
       "      <td>387.58</td>\n",
       "      <td>331.20</td>\n",
       "      <td>...</td>\n",
       "      <td>1461.68</td>\n",
       "      <td>1035.38</td>\n",
       "      <td>1619.68</td>\n",
       "      <td>948.00</td>\n",
       "      <td>1406.61</td>\n",
       "      <td>955.95</td>\n",
       "      <td>942.13</td>\n",
       "      <td>974.21</td>\n",
       "      <td>2525.47</td>\n",
       "      <td>2759.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Hebei</td>\n",
       "      <td>Shijiazhuang</td>\n",
       "      <td>City3</td>\n",
       "      <td>239.46</td>\n",
       "      <td>269.63</td>\n",
       "      <td>0.00</td>\n",
       "      <td>363.06</td>\n",
       "      <td>470.05</td>\n",
       "      <td>184.80</td>\n",
       "      <td>109.09</td>\n",
       "      <td>...</td>\n",
       "      <td>1226.96</td>\n",
       "      <td>766.38</td>\n",
       "      <td>1395.66</td>\n",
       "      <td>678.54</td>\n",
       "      <td>1150.32</td>\n",
       "      <td>712.93</td>\n",
       "      <td>712.21</td>\n",
       "      <td>721.68</td>\n",
       "      <td>2340.00</td>\n",
       "      <td>2590.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Hebei</td>\n",
       "      <td>Tangshan</td>\n",
       "      <td>City9</td>\n",
       "      <td>162.11</td>\n",
       "      <td>93.42</td>\n",
       "      <td>363.06</td>\n",
       "      <td>0.00</td>\n",
       "      <td>108.66</td>\n",
       "      <td>474.06</td>\n",
       "      <td>421.57</td>\n",
       "      <td>...</td>\n",
       "      <td>1545.12</td>\n",
       "      <td>1128.59</td>\n",
       "      <td>1699.74</td>\n",
       "      <td>1041.34</td>\n",
       "      <td>1496.18</td>\n",
       "      <td>1042.78</td>\n",
       "      <td>1025.79</td>\n",
       "      <td>1063.33</td>\n",
       "      <td>2592.22</td>\n",
       "      <td>2821.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Hebei</td>\n",
       "      <td>Qinghuangdao</td>\n",
       "      <td>City12</td>\n",
       "      <td>266.93</td>\n",
       "      <td>200.99</td>\n",
       "      <td>470.05</td>\n",
       "      <td>108.66</td>\n",
       "      <td>0.00</td>\n",
       "      <td>569.15</td>\n",
       "      <td>522.10</td>\n",
       "      <td>...</td>\n",
       "      <td>1650.75</td>\n",
       "      <td>1236.22</td>\n",
       "      <td>1803.26</td>\n",
       "      <td>1148.59</td>\n",
       "      <td>1604.59</td>\n",
       "      <td>1150.30</td>\n",
       "      <td>1131.81</td>\n",
       "      <td>1171.65</td>\n",
       "      <td>2685.20</td>\n",
       "      <td>2909.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273</th>\n",
       "      <td>Ningxia</td>\n",
       "      <td>Yinchuan</td>\n",
       "      <td>City600</td>\n",
       "      <td>884.18</td>\n",
       "      <td>955.95</td>\n",
       "      <td>712.93</td>\n",
       "      <td>1042.78</td>\n",
       "      <td>1150.30</td>\n",
       "      <td>749.36</td>\n",
       "      <td>730.06</td>\n",
       "      <td>...</td>\n",
       "      <td>515.52</td>\n",
       "      <td>329.09</td>\n",
       "      <td>692.61</td>\n",
       "      <td>332.77</td>\n",
       "      <td>464.56</td>\n",
       "      <td>0.00</td>\n",
       "      <td>83.65</td>\n",
       "      <td>75.82</td>\n",
       "      <td>1680.02</td>\n",
       "      <td>1953.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274</th>\n",
       "      <td>Ningxia</td>\n",
       "      <td>Shizuishan</td>\n",
       "      <td>City601</td>\n",
       "      <td>864.88</td>\n",
       "      <td>942.13</td>\n",
       "      <td>712.21</td>\n",
       "      <td>1025.79</td>\n",
       "      <td>1131.81</td>\n",
       "      <td>768.90</td>\n",
       "      <td>741.66</td>\n",
       "      <td>...</td>\n",
       "      <td>519.55</td>\n",
       "      <td>412.18</td>\n",
       "      <td>683.44</td>\n",
       "      <td>410.93</td>\n",
       "      <td>510.43</td>\n",
       "      <td>83.65</td>\n",
       "      <td>0.00</td>\n",
       "      <td>159.47</td>\n",
       "      <td>1649.81</td>\n",
       "      <td>1917.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>275</th>\n",
       "      <td>Ningxia</td>\n",
       "      <td>Wuzhong</td>\n",
       "      <td>City602</td>\n",
       "      <td>907.68</td>\n",
       "      <td>974.21</td>\n",
       "      <td>721.68</td>\n",
       "      <td>1063.33</td>\n",
       "      <td>1171.65</td>\n",
       "      <td>739.10</td>\n",
       "      <td>727.42</td>\n",
       "      <td>...</td>\n",
       "      <td>523.78</td>\n",
       "      <td>254.02</td>\n",
       "      <td>709.63</td>\n",
       "      <td>264.69</td>\n",
       "      <td>433.10</td>\n",
       "      <td>75.82</td>\n",
       "      <td>159.47</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1710.67</td>\n",
       "      <td>1989.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276</th>\n",
       "      <td>Xinjiang</td>\n",
       "      <td>Wulumuqi</td>\n",
       "      <td>City604</td>\n",
       "      <td>2433.90</td>\n",
       "      <td>2525.47</td>\n",
       "      <td>2340.00</td>\n",
       "      <td>2592.22</td>\n",
       "      <td>2685.20</td>\n",
       "      <td>2417.82</td>\n",
       "      <td>2385.54</td>\n",
       "      <td>...</td>\n",
       "      <td>1210.86</td>\n",
       "      <td>1865.18</td>\n",
       "      <td>1015.79</td>\n",
       "      <td>1932.21</td>\n",
       "      <td>1436.67</td>\n",
       "      <td>1680.02</td>\n",
       "      <td>1649.81</td>\n",
       "      <td>1710.67</td>\n",
       "      <td>0.00</td>\n",
       "      <td>310.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>277</th>\n",
       "      <td>Xinjiang</td>\n",
       "      <td>Kelamayi</td>\n",
       "      <td>City605</td>\n",
       "      <td>2666.29</td>\n",
       "      <td>2759.92</td>\n",
       "      <td>2590.30</td>\n",
       "      <td>2821.25</td>\n",
       "      <td>2909.44</td>\n",
       "      <td>2679.98</td>\n",
       "      <td>2643.04</td>\n",
       "      <td>...</td>\n",
       "      <td>1503.68</td>\n",
       "      <td>2157.09</td>\n",
       "      <td>1309.31</td>\n",
       "      <td>2220.51</td>\n",
       "      <td>1737.78</td>\n",
       "      <td>1953.97</td>\n",
       "      <td>1917.17</td>\n",
       "      <td>1989.97</td>\n",
       "      <td>310.74</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>278 rows × 281 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      proveng       cityeng cityseries    city1    city2    city3    city9  \\\n",
       "0     Beijing       Beijing      City1     0.00    96.06   239.46   162.11   \n",
       "1     Tianjin       Tianjin      City2    96.06     0.00   269.63    93.42   \n",
       "2       Hebei  Shijiazhuang      City3   239.46   269.63     0.00   363.06   \n",
       "3       Hebei      Tangshan      City9   162.11    93.42   363.06     0.00   \n",
       "4       Hebei  Qinghuangdao     City12   266.93   200.99   470.05   108.66   \n",
       "..        ...           ...        ...      ...      ...      ...      ...   \n",
       "273   Ningxia      Yinchuan    City600   884.18   955.95   712.93  1042.78   \n",
       "274   Ningxia    Shizuishan    City601   864.88   942.13   712.21  1025.79   \n",
       "275   Ningxia       Wuzhong    City602   907.68   974.21   721.68  1063.33   \n",
       "276  Xinjiang      Wulumuqi    City604  2433.90  2525.47  2340.00  2592.22   \n",
       "277  Xinjiang      Kelamayi    City605  2666.29  2759.92  2590.30  2821.25   \n",
       "\n",
       "      city12   city13   city15  ...  City590  City591  City592  City595  \\\n",
       "0     266.93   394.54   326.77  ...  1383.90   988.22  1537.70   903.66   \n",
       "1     200.99   387.58   331.20  ...  1461.68  1035.38  1619.68   948.00   \n",
       "2     470.05   184.80   109.09  ...  1226.96   766.38  1395.66   678.54   \n",
       "3     108.66   474.06   421.57  ...  1545.12  1128.59  1699.74  1041.34   \n",
       "4       0.00   569.15   522.10  ...  1650.75  1236.22  1803.26  1148.59   \n",
       "..       ...      ...      ...  ...      ...      ...      ...      ...   \n",
       "273  1150.30   749.36   730.06  ...   515.52   329.09   692.61   332.77   \n",
       "274  1131.81   768.90   741.66  ...   519.55   412.18   683.44   410.93   \n",
       "275  1171.65   739.10   727.42  ...   523.78   254.02   709.63   264.69   \n",
       "276  2685.20  2417.82  2385.54  ...  1210.86  1865.18  1015.79  1932.21   \n",
       "277  2909.44  2679.98  2643.04  ...  1503.68  2157.09  1309.31  2220.51   \n",
       "\n",
       "     City597  City600  City601  City602  City604  City605  \n",
       "0    1340.78   884.18   864.88   907.68  2433.90  2666.29  \n",
       "1    1406.61   955.95   942.13   974.21  2525.47  2759.92  \n",
       "2    1150.32   712.93   712.21   721.68  2340.00  2590.30  \n",
       "3    1496.18  1042.78  1025.79  1063.33  2592.22  2821.25  \n",
       "4    1604.59  1150.30  1131.81  1171.65  2685.20  2909.44  \n",
       "..       ...      ...      ...      ...      ...      ...  \n",
       "273   464.56     0.00    83.65    75.82  1680.02  1953.97  \n",
       "274   510.43    83.65     0.00   159.47  1649.81  1917.17  \n",
       "275   433.10    75.82   159.47     0.00  1710.67  1989.97  \n",
       "276  1436.67  1680.02  1649.81  1710.67     0.00   310.74  \n",
       "277  1737.78  1953.97  1917.17  1989.97   310.74     0.00  \n",
       "\n",
       "[278 rows x 281 columns]"
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# # 获取DataFrame的形状\n",
    "# shape = df.shape\n",
    "# print(\"DataFrame的形状：\", shape)\n",
    "\n",
    "# # 获取DataFrame的列名\n",
    "# columns = df.columns\n",
    "# print(\"DataFrame的列名：\", columns)\n",
    "\n",
    "# # 获取DataFrame的数据类型信息\n",
    "# dtypes = df.dtypes\n",
    "# print(\"DataFrame的数据类型信息：\")\n",
    "# print(dtypes)\n",
    "\n",
    "# # 获取DataFrame的摘要统计信息\n",
    "# summary = df.describe()\n",
    "# print(\"DataFrame的摘要统计信息：\")\n",
    "# print(summary)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "278\n",
      "278\n",
      "provinces ['Beijing' 'Tianjin' 'Hebei' 'Hebei' 'Hebei' 'Hebei' 'Hebei' 'Hebei'\n",
      " 'Hebei' 'Hebei']\n",
      "citys ['Beijing' 'Tianjin' 'Shijiazhuang' 'Tangshan' 'Qinghuangdao' 'Handan'\n",
      " 'Xingtai' 'Baoding' 'Zhuangjiakou' 'Chengde']\n",
      "[[   0.     96.06  239.46 ...  907.68 2433.9  2666.29]\n",
      " [  96.06    0.    269.63 ...  974.21 2525.47 2759.92]\n",
      " [ 239.46  269.63    0.   ...  721.68 2340.   2590.3 ]\n",
      " ...\n",
      " [ 907.68  974.21  721.68 ...    0.   1710.67 1989.97]\n",
      " [2433.9  2525.47 2340.   ... 1710.67    0.    310.74]\n",
      " [2666.29 2759.92 2590.3  ... 1989.97  310.74    0.  ]]\n"
     ]
    }
   ],
   "source": [
    "# 提取省份列和矩阵部分（假设矩阵的数据从第2行开始，第2列开始）\n",
    "provinces = df.iloc[:, 0].values\n",
    "citys = df.iloc[:, 1].values\n",
    "matrix = df.iloc[0:, 3:].values\n",
    "print(len(provinces))\n",
    "print(len(citys))\n",
    "print(\"provinces\", provinces[:10])\n",
    "print(\"citys\", citys[:10])\n",
    "print(matrix)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 139,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "挑选出的省份： ['Anhui', 'Jiangsu', 'Zhejiang', 'Shanghai']\n",
      "挑选出的城市： 41 selected_cities: ['Shanghai', 'Nanjing', 'Wuxi', 'Xuzhou', 'Changzhou', 'Nantong', 'huaian', 'yancheng', 'Yangzhou', 'zhenjiang', 'Taizhou', 'Suqian', 'Hangzhou', 'ningbo', 'Wenzhou', 'Jiaxing', 'Huzhou', 'Shaoxing', 'Jinhua', 'Quzhou', 'Zhoushan', 'Taizhou', 'Lishui', 'Hefei', 'Wuhu', 'Bengbu', 'Huainan', 'Maanshan', 'Huaibei', 'Tongling', 'Anqing', 'Huangshan', 'Chuzhou', 'Fuyang', 'Suzhou', 'suzhou', 'liuan', 'Bozhou', 'chizou', 'xuancheng', 'Lianyungang']\n",
      "挑选出的索引： [66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 186]\n",
      "对应的矩阵数据：\n",
      "(41, 278)\n",
      "selected_matrix\n",
      " [[1041.97  955.6   997.79 ... 1566.06 3272.88 3542.88]\n",
      " [ 860.69  787.49  766.85 ... 1285.73 2995.23 3268.88]\n",
      " [ 980.99  898.94  917.49 ... 1464.53 3173.14 3445.22]\n",
      " ...\n",
      " [1024.05  960.78  892.4  ... 1304.18 3010.26 3293.63]\n",
      " [1019.42  948.3   912.26 ... 1377.54 3087.39 3367.15]\n",
      " [ 631.17  547.98  593.09 ... 1222.99 2908.48 3168.8 ]]\n",
      "selected_indices_str\n",
      " 41 ['City158' 'City159' 'City160' 'City163' 'City166' 'City174' 'City179'\n",
      " 'City181' 'City183' 'City187' 'City190' 'City195' 'City196' 'City201'\n",
      " 'City205' 'City208' 'City212' 'City213' 'City216' 'City221' 'City223'\n",
      " 'City224' 'City227' 'City229' 'City230' 'City231' 'City232' 'City233'\n",
      " 'City234' 'City235' 'City236' 'City237' 'City238' 'City241' 'City243'\n",
      " 'City244' 'City246' 'City247' 'City248' 'City249' 'City433']\n"
     ]
    }
   ],
   "source": [
    "# \n",
    "distance_matrix = df.iloc[:, 3:]\n",
    "city_index = 2\n",
    "distance_matrix.index = df.iloc[:, city_index].values\n",
    "distance_matrix.columns = df.iloc[:, city_index].values\n",
    "\n",
    "# 挑选出安徽、江苏、浙江和上海的省份及对应的矩阵数据\n",
    "selected_provinces = ['Anhui', 'Jiangsu', 'Zhejiang', 'Shanghai']\n",
    "selected_cities = df[df['proveng'].isin(selected_provinces)]['cityeng'].tolist()\n",
    "selected_indices = [i for i, prov in enumerate(provinces) if prov in selected_provinces]\n",
    "selected_matrix = matrix[selected_indices, :]\n",
    "selected_indices_str = df.values[selected_indices, city_index]\n",
    "# 打印挑选出的省份及对应的矩阵数据\n",
    "print(\"挑选出的省份：\", selected_provinces)\n",
    "print(\"挑选出的城市：\", len(selected_cities), \"selected_cities:\", selected_cities)\n",
    "print(\"挑选出的索引：\", selected_indices)\n",
    "print(\"对应的矩阵数据：\")\n",
    "print(selected_matrix.shape)\n",
    "print(\"selected_matrix\\n\", selected_matrix)\n",
    "print(\"selected_indices_str\\n\", len(selected_indices_str), selected_indices_str)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 140,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>City1</th>\n",
       "      <th>City2</th>\n",
       "      <th>City3</th>\n",
       "      <th>City9</th>\n",
       "      <th>City12</th>\n",
       "      <th>City13</th>\n",
       "      <th>City15</th>\n",
       "      <th>City18</th>\n",
       "      <th>City23</th>\n",
       "      <th>City24</th>\n",
       "      <th>...</th>\n",
       "      <th>City590</th>\n",
       "      <th>City591</th>\n",
       "      <th>City592</th>\n",
       "      <th>City595</th>\n",
       "      <th>City597</th>\n",
       "      <th>City600</th>\n",
       "      <th>City601</th>\n",
       "      <th>City602</th>\n",
       "      <th>City604</th>\n",
       "      <th>City605</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>City1</th>\n",
       "      <td>0.00</td>\n",
       "      <td>96.06</td>\n",
       "      <td>239.46</td>\n",
       "      <td>162.11</td>\n",
       "      <td>266.93</td>\n",
       "      <td>394.54</td>\n",
       "      <td>326.77</td>\n",
       "      <td>141.46</td>\n",
       "      <td>178.80</td>\n",
       "      <td>161.98</td>\n",
       "      <td>...</td>\n",
       "      <td>1383.90</td>\n",
       "      <td>988.22</td>\n",
       "      <td>1537.70</td>\n",
       "      <td>903.66</td>\n",
       "      <td>1340.78</td>\n",
       "      <td>884.18</td>\n",
       "      <td>864.88</td>\n",
       "      <td>907.68</td>\n",
       "      <td>2433.90</td>\n",
       "      <td>2666.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City2</th>\n",
       "      <td>96.06</td>\n",
       "      <td>0.00</td>\n",
       "      <td>269.63</td>\n",
       "      <td>93.42</td>\n",
       "      <td>200.99</td>\n",
       "      <td>387.58</td>\n",
       "      <td>331.20</td>\n",
       "      <td>167.86</td>\n",
       "      <td>274.85</td>\n",
       "      <td>178.96</td>\n",
       "      <td>...</td>\n",
       "      <td>1461.68</td>\n",
       "      <td>1035.38</td>\n",
       "      <td>1619.68</td>\n",
       "      <td>948.00</td>\n",
       "      <td>1406.61</td>\n",
       "      <td>955.95</td>\n",
       "      <td>942.13</td>\n",
       "      <td>974.21</td>\n",
       "      <td>2525.47</td>\n",
       "      <td>2759.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City3</th>\n",
       "      <td>239.46</td>\n",
       "      <td>269.63</td>\n",
       "      <td>0.00</td>\n",
       "      <td>363.06</td>\n",
       "      <td>470.05</td>\n",
       "      <td>184.80</td>\n",
       "      <td>109.09</td>\n",
       "      <td>103.02</td>\n",
       "      <td>274.56</td>\n",
       "      <td>401.41</td>\n",
       "      <td>...</td>\n",
       "      <td>1226.96</td>\n",
       "      <td>766.38</td>\n",
       "      <td>1395.66</td>\n",
       "      <td>678.54</td>\n",
       "      <td>1150.32</td>\n",
       "      <td>712.93</td>\n",
       "      <td>712.21</td>\n",
       "      <td>721.68</td>\n",
       "      <td>2340.00</td>\n",
       "      <td>2590.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City9</th>\n",
       "      <td>162.11</td>\n",
       "      <td>93.42</td>\n",
       "      <td>363.06</td>\n",
       "      <td>0.00</td>\n",
       "      <td>108.66</td>\n",
       "      <td>474.06</td>\n",
       "      <td>421.57</td>\n",
       "      <td>261.06</td>\n",
       "      <td>330.05</td>\n",
       "      <td>144.46</td>\n",
       "      <td>...</td>\n",
       "      <td>1545.12</td>\n",
       "      <td>1128.59</td>\n",
       "      <td>1699.74</td>\n",
       "      <td>1041.34</td>\n",
       "      <td>1496.18</td>\n",
       "      <td>1042.78</td>\n",
       "      <td>1025.79</td>\n",
       "      <td>1063.33</td>\n",
       "      <td>2592.22</td>\n",
       "      <td>2821.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City12</th>\n",
       "      <td>266.93</td>\n",
       "      <td>200.99</td>\n",
       "      <td>470.05</td>\n",
       "      <td>108.66</td>\n",
       "      <td>0.00</td>\n",
       "      <td>569.15</td>\n",
       "      <td>522.10</td>\n",
       "      <td>368.82</td>\n",
       "      <td>423.71</td>\n",
       "      <td>190.77</td>\n",
       "      <td>...</td>\n",
       "      <td>1650.75</td>\n",
       "      <td>1236.22</td>\n",
       "      <td>1803.26</td>\n",
       "      <td>1148.59</td>\n",
       "      <td>1604.59</td>\n",
       "      <td>1150.30</td>\n",
       "      <td>1131.81</td>\n",
       "      <td>1171.65</td>\n",
       "      <td>2685.20</td>\n",
       "      <td>2909.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City600</th>\n",
       "      <td>884.18</td>\n",
       "      <td>955.95</td>\n",
       "      <td>712.93</td>\n",
       "      <td>1042.78</td>\n",
       "      <td>1150.30</td>\n",
       "      <td>749.36</td>\n",
       "      <td>730.06</td>\n",
       "      <td>797.58</td>\n",
       "      <td>760.72</td>\n",
       "      <td>1013.65</td>\n",
       "      <td>...</td>\n",
       "      <td>515.52</td>\n",
       "      <td>329.09</td>\n",
       "      <td>692.61</td>\n",
       "      <td>332.77</td>\n",
       "      <td>464.56</td>\n",
       "      <td>0.00</td>\n",
       "      <td>83.65</td>\n",
       "      <td>75.82</td>\n",
       "      <td>1680.02</td>\n",
       "      <td>1953.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City601</th>\n",
       "      <td>864.88</td>\n",
       "      <td>942.13</td>\n",
       "      <td>712.21</td>\n",
       "      <td>1025.79</td>\n",
       "      <td>1131.81</td>\n",
       "      <td>768.90</td>\n",
       "      <td>741.66</td>\n",
       "      <td>789.82</td>\n",
       "      <td>729.25</td>\n",
       "      <td>985.49</td>\n",
       "      <td>...</td>\n",
       "      <td>519.55</td>\n",
       "      <td>412.18</td>\n",
       "      <td>683.44</td>\n",
       "      <td>410.93</td>\n",
       "      <td>510.43</td>\n",
       "      <td>83.65</td>\n",
       "      <td>0.00</td>\n",
       "      <td>159.47</td>\n",
       "      <td>1649.81</td>\n",
       "      <td>1917.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City602</th>\n",
       "      <td>907.68</td>\n",
       "      <td>974.21</td>\n",
       "      <td>721.68</td>\n",
       "      <td>1063.33</td>\n",
       "      <td>1171.65</td>\n",
       "      <td>739.10</td>\n",
       "      <td>727.42</td>\n",
       "      <td>811.73</td>\n",
       "      <td>795.52</td>\n",
       "      <td>1044.00</td>\n",
       "      <td>...</td>\n",
       "      <td>523.78</td>\n",
       "      <td>254.02</td>\n",
       "      <td>709.63</td>\n",
       "      <td>264.69</td>\n",
       "      <td>433.10</td>\n",
       "      <td>75.82</td>\n",
       "      <td>159.47</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1710.67</td>\n",
       "      <td>1989.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City604</th>\n",
       "      <td>2433.90</td>\n",
       "      <td>2525.47</td>\n",
       "      <td>2340.00</td>\n",
       "      <td>2592.22</td>\n",
       "      <td>2685.20</td>\n",
       "      <td>2417.82</td>\n",
       "      <td>2385.54</td>\n",
       "      <td>2399.36</td>\n",
       "      <td>2262.75</td>\n",
       "      <td>2504.61</td>\n",
       "      <td>...</td>\n",
       "      <td>1210.86</td>\n",
       "      <td>1865.18</td>\n",
       "      <td>1015.79</td>\n",
       "      <td>1932.21</td>\n",
       "      <td>1436.67</td>\n",
       "      <td>1680.02</td>\n",
       "      <td>1649.81</td>\n",
       "      <td>1710.67</td>\n",
       "      <td>0.00</td>\n",
       "      <td>310.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City605</th>\n",
       "      <td>2666.29</td>\n",
       "      <td>2759.92</td>\n",
       "      <td>2590.30</td>\n",
       "      <td>2821.25</td>\n",
       "      <td>2909.44</td>\n",
       "      <td>2679.98</td>\n",
       "      <td>2643.04</td>\n",
       "      <td>2642.96</td>\n",
       "      <td>2491.30</td>\n",
       "      <td>2724.37</td>\n",
       "      <td>...</td>\n",
       "      <td>1503.68</td>\n",
       "      <td>2157.09</td>\n",
       "      <td>1309.31</td>\n",
       "      <td>2220.51</td>\n",
       "      <td>1737.78</td>\n",
       "      <td>1953.97</td>\n",
       "      <td>1917.17</td>\n",
       "      <td>1989.97</td>\n",
       "      <td>310.74</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>278 rows × 278 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           City1    City2    City3    City9   City12   City13   City15  \\\n",
       "City1       0.00    96.06   239.46   162.11   266.93   394.54   326.77   \n",
       "City2      96.06     0.00   269.63    93.42   200.99   387.58   331.20   \n",
       "City3     239.46   269.63     0.00   363.06   470.05   184.80   109.09   \n",
       "City9     162.11    93.42   363.06     0.00   108.66   474.06   421.57   \n",
       "City12    266.93   200.99   470.05   108.66     0.00   569.15   522.10   \n",
       "...          ...      ...      ...      ...      ...      ...      ...   \n",
       "City600   884.18   955.95   712.93  1042.78  1150.30   749.36   730.06   \n",
       "City601   864.88   942.13   712.21  1025.79  1131.81   768.90   741.66   \n",
       "City602   907.68   974.21   721.68  1063.33  1171.65   739.10   727.42   \n",
       "City604  2433.90  2525.47  2340.00  2592.22  2685.20  2417.82  2385.54   \n",
       "City605  2666.29  2759.92  2590.30  2821.25  2909.44  2679.98  2643.04   \n",
       "\n",
       "          City18   City23   City24  ...  City590  City591  City592  City595  \\\n",
       "City1     141.46   178.80   161.98  ...  1383.90   988.22  1537.70   903.66   \n",
       "City2     167.86   274.85   178.96  ...  1461.68  1035.38  1619.68   948.00   \n",
       "City3     103.02   274.56   401.41  ...  1226.96   766.38  1395.66   678.54   \n",
       "City9     261.06   330.05   144.46  ...  1545.12  1128.59  1699.74  1041.34   \n",
       "City12    368.82   423.71   190.77  ...  1650.75  1236.22  1803.26  1148.59   \n",
       "...          ...      ...      ...  ...      ...      ...      ...      ...   \n",
       "City600   797.58   760.72  1013.65  ...   515.52   329.09   692.61   332.77   \n",
       "City601   789.82   729.25   985.49  ...   519.55   412.18   683.44   410.93   \n",
       "City602   811.73   795.52  1044.00  ...   523.78   254.02   709.63   264.69   \n",
       "City604  2399.36  2262.75  2504.61  ...  1210.86  1865.18  1015.79  1932.21   \n",
       "City605  2642.96  2491.30  2724.37  ...  1503.68  2157.09  1309.31  2220.51   \n",
       "\n",
       "         City597  City600  City601  City602  City604  City605  \n",
       "City1    1340.78   884.18   864.88   907.68  2433.90  2666.29  \n",
       "City2    1406.61   955.95   942.13   974.21  2525.47  2759.92  \n",
       "City3    1150.32   712.93   712.21   721.68  2340.00  2590.30  \n",
       "City9    1496.18  1042.78  1025.79  1063.33  2592.22  2821.25  \n",
       "City12   1604.59  1150.30  1131.81  1171.65  2685.20  2909.44  \n",
       "...          ...      ...      ...      ...      ...      ...  \n",
       "City600   464.56     0.00    83.65    75.82  1680.02  1953.97  \n",
       "City601   510.43    83.65     0.00   159.47  1649.81  1917.17  \n",
       "City602   433.10    75.82   159.47     0.00  1710.67  1989.97  \n",
       "City604  1436.67  1680.02  1649.81  1710.67     0.00   310.74  \n",
       "City605  1737.78  1953.97  1917.17  1989.97   310.74     0.00  \n",
       "\n",
       "[278 rows x 278 columns]"
      ]
     },
     "execution_count": 140,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# distance_matrix[:, selected_cities_str]\n",
    "# matrix\n",
    "# distance_matrix\n",
    "# list\n",
    "# distance_matrix.values "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 144,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "City158\n",
      "25\n",
      "26\n",
      "(26, 26)\n"
     ]
    }
   ],
   "source": [
    "# 从城市列表中随机选择25个城市（不包括上海）\n",
    "selected_index = pd.Index(selected_indices_str)\n",
    "# 使用 loc 方法选择相应的行和列\n",
    "selected_data = distance_matrix.loc[selected_index, selected_index]\n",
    "np.random.seed(42)\n",
    "print(selected_indices_str[0])\n",
    "random_cities = np.random.choice(selected_indices_str[1:], 25, replace=False)\n",
    "print(len(random_cities))\n",
    "# 将上海添加到随机选择的城市列表中 \n",
    "# City158 = shanghai\n",
    "selected_cities_26 = ['City158'] + random_cities.tolist()\n",
    "print(len(selected_cities_26))\n",
    "selected_index_26 = pd.Index(selected_cities_26)\n",
    "# 使用 loc 方法选择相应的行和列\n",
    "\n",
    "\n",
    "selected_data_26 = selected_data.loc[selected_index_26, selected_index_26]\n",
    "city_to_city_series = df[['cityeng', 'cityseries']].drop_duplicates().set_index('cityeng')['cityseries'].to_dict()\n",
    "city_series_to_city = df[['cityeng', 'cityseries']].drop_duplicates().set_index('cityseries')['cityeng'].to_dict()\n",
    "city_series_26_columns = selected_data_26.columns\n",
    "city_26_columns = []\n",
    "for item in city_series_26_columns:\n",
    "    city_26_columns.append(city_series_to_city[item])\n",
    "city_26 = pd.DataFrame(selected_data_26.values, index=city_26_columns, columns=city_26_columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 145,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>City158</th>\n",
       "      <th>City223</th>\n",
       "      <th>City213</th>\n",
       "      <th>City212</th>\n",
       "      <th>City233</th>\n",
       "      <th>City174</th>\n",
       "      <th>City201</th>\n",
       "      <th>City248</th>\n",
       "      <th>City234</th>\n",
       "      <th>City433</th>\n",
       "      <th>...</th>\n",
       "      <th>City187</th>\n",
       "      <th>City216</th>\n",
       "      <th>City231</th>\n",
       "      <th>City159</th>\n",
       "      <th>City243</th>\n",
       "      <th>City179</th>\n",
       "      <th>City196</th>\n",
       "      <th>City160</th>\n",
       "      <th>City236</th>\n",
       "      <th>City227</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>City158</th>\n",
       "      <td>0.00</td>\n",
       "      <td>145.84</td>\n",
       "      <td>156.19</td>\n",
       "      <td>136.34</td>\n",
       "      <td>288.14</td>\n",
       "      <td>121.87</td>\n",
       "      <td>180.37</td>\n",
       "      <td>392.51</td>\n",
       "      <td>527.73</td>\n",
       "      <td>412.91</td>\n",
       "      <td>...</td>\n",
       "      <td>219.81</td>\n",
       "      <td>294.22</td>\n",
       "      <td>416.88</td>\n",
       "      <td>286.05</td>\n",
       "      <td>508.59</td>\n",
       "      <td>317.38</td>\n",
       "      <td>157.76</td>\n",
       "      <td>107.97</td>\n",
       "      <td>418.88</td>\n",
       "      <td>361.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City223</th>\n",
       "      <td>145.84</td>\n",
       "      <td>0.00</td>\n",
       "      <td>165.81</td>\n",
       "      <td>200.50</td>\n",
       "      <td>394.74</td>\n",
       "      <td>267.26</td>\n",
       "      <td>89.17</td>\n",
       "      <td>461.78</td>\n",
       "      <td>660.70</td>\n",
       "      <td>558.70</td>\n",
       "      <td>...</td>\n",
       "      <td>354.13</td>\n",
       "      <td>278.94</td>\n",
       "      <td>541.62</td>\n",
       "      <td>410.45</td>\n",
       "      <td>640.24</td>\n",
       "      <td>461.82</td>\n",
       "      <td>189.52</td>\n",
       "      <td>233.06</td>\n",
       "      <td>486.19</td>\n",
       "      <td>312.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City213</th>\n",
       "      <td>156.19</td>\n",
       "      <td>165.81</td>\n",
       "      <td>0.00</td>\n",
       "      <td>63.84</td>\n",
       "      <td>253.38</td>\n",
       "      <td>224.34</td>\n",
       "      <td>109.58</td>\n",
       "      <td>297.58</td>\n",
       "      <td>540.29</td>\n",
       "      <td>499.18</td>\n",
       "      <td>...</td>\n",
       "      <td>256.08</td>\n",
       "      <td>138.50</td>\n",
       "      <td>412.11</td>\n",
       "      <td>288.48</td>\n",
       "      <td>517.98</td>\n",
       "      <td>385.97</td>\n",
       "      <td>29.18</td>\n",
       "      <td>149.95</td>\n",
       "      <td>321.41</td>\n",
       "      <td>207.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City212</th>\n",
       "      <td>136.34</td>\n",
       "      <td>200.50</td>\n",
       "      <td>63.84</td>\n",
       "      <td>0.00</td>\n",
       "      <td>197.79</td>\n",
       "      <td>171.30</td>\n",
       "      <td>165.46</td>\n",
       "      <td>267.15</td>\n",
       "      <td>479.52</td>\n",
       "      <td>436.86</td>\n",
       "      <td>...</td>\n",
       "      <td>192.27</td>\n",
       "      <td>173.90</td>\n",
       "      <td>353.07</td>\n",
       "      <td>226.77</td>\n",
       "      <td>457.54</td>\n",
       "      <td>322.75</td>\n",
       "      <td>40.26</td>\n",
       "      <td>92.00</td>\n",
       "      <td>292.75</td>\n",
       "      <td>255.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City233</th>\n",
       "      <td>288.14</td>\n",
       "      <td>394.74</td>\n",
       "      <td>253.38</td>\n",
       "      <td>197.79</td>\n",
       "      <td>0.00</td>\n",
       "      <td>220.80</td>\n",
       "      <td>361.66</td>\n",
       "      <td>150.08</td>\n",
       "      <td>292.61</td>\n",
       "      <td>335.04</td>\n",
       "      <td>...</td>\n",
       "      <td>120.45</td>\n",
       "      <td>283.55</td>\n",
       "      <td>161.33</td>\n",
       "      <td>68.93</td>\n",
       "      <td>269.52</td>\n",
       "      <td>221.65</td>\n",
       "      <td>224.21</td>\n",
       "      <td>180.83</td>\n",
       "      <td>173.31</td>\n",
       "      <td>372.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City174</th>\n",
       "      <td>121.87</td>\n",
       "      <td>267.26</td>\n",
       "      <td>224.34</td>\n",
       "      <td>171.30</td>\n",
       "      <td>220.80</td>\n",
       "      <td>0.00</td>\n",
       "      <td>288.06</td>\n",
       "      <td>356.50</td>\n",
       "      <td>416.00</td>\n",
       "      <td>292.72</td>\n",
       "      <td>...</td>\n",
       "      <td>117.50</td>\n",
       "      <td>344.43</td>\n",
       "      <td>316.51</td>\n",
       "      <td>193.49</td>\n",
       "      <td>398.46</td>\n",
       "      <td>195.78</td>\n",
       "      <td>209.62</td>\n",
       "      <td>80.86</td>\n",
       "      <td>382.50</td>\n",
       "      <td>426.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City201</th>\n",
       "      <td>180.37</td>\n",
       "      <td>89.17</td>\n",
       "      <td>109.58</td>\n",
       "      <td>165.46</td>\n",
       "      <td>361.66</td>\n",
       "      <td>288.06</td>\n",
       "      <td>0.00</td>\n",
       "      <td>402.42</td>\n",
       "      <td>644.67</td>\n",
       "      <td>578.45</td>\n",
       "      <td>...</td>\n",
       "      <td>349.14</td>\n",
       "      <td>194.88</td>\n",
       "      <td>518.50</td>\n",
       "      <td>391.65</td>\n",
       "      <td>622.82</td>\n",
       "      <td>471.49</td>\n",
       "      <td>138.50</td>\n",
       "      <td>230.70</td>\n",
       "      <td>425.02</td>\n",
       "      <td>223.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City248</th>\n",
       "      <td>392.51</td>\n",
       "      <td>461.78</td>\n",
       "      <td>297.58</td>\n",
       "      <td>267.15</td>\n",
       "      <td>150.08</td>\n",
       "      <td>356.50</td>\n",
       "      <td>402.42</td>\n",
       "      <td>0.00</td>\n",
       "      <td>362.14</td>\n",
       "      <td>473.87</td>\n",
       "      <td>...</td>\n",
       "      <td>269.30</td>\n",
       "      <td>251.38</td>\n",
       "      <td>241.65</td>\n",
       "      <td>214.35</td>\n",
       "      <td>339.34</td>\n",
       "      <td>366.35</td>\n",
       "      <td>272.30</td>\n",
       "      <td>296.58</td>\n",
       "      <td>26.51</td>\n",
       "      <td>322.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City234</th>\n",
       "      <td>527.73</td>\n",
       "      <td>660.70</td>\n",
       "      <td>540.29</td>\n",
       "      <td>479.52</td>\n",
       "      <td>292.61</td>\n",
       "      <td>416.00</td>\n",
       "      <td>644.67</td>\n",
       "      <td>362.14</td>\n",
       "      <td>0.00</td>\n",
       "      <td>258.24</td>\n",
       "      <td>...</td>\n",
       "      <td>308.19</td>\n",
       "      <td>572.67</td>\n",
       "      <td>131.94</td>\n",
       "      <td>253.09</td>\n",
       "      <td>23.49</td>\n",
       "      <td>245.23</td>\n",
       "      <td>511.65</td>\n",
       "      <td>427.81</td>\n",
       "      <td>366.59</td>\n",
       "      <td>658.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City433</th>\n",
       "      <td>412.91</td>\n",
       "      <td>558.70</td>\n",
       "      <td>499.18</td>\n",
       "      <td>436.86</td>\n",
       "      <td>335.04</td>\n",
       "      <td>292.72</td>\n",
       "      <td>578.45</td>\n",
       "      <td>473.87</td>\n",
       "      <td>258.24</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>250.96</td>\n",
       "      <td>589.50</td>\n",
       "      <td>266.37</td>\n",
       "      <td>266.13</td>\n",
       "      <td>257.18</td>\n",
       "      <td>118.00</td>\n",
       "      <td>476.91</td>\n",
       "      <td>351.01</td>\n",
       "      <td>491.41</td>\n",
       "      <td>679.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City181</th>\n",
       "      <td>258.08</td>\n",
       "      <td>403.60</td>\n",
       "      <td>359.28</td>\n",
       "      <td>300.56</td>\n",
       "      <td>261.47</td>\n",
       "      <td>140.59</td>\n",
       "      <td>428.66</td>\n",
       "      <td>411.55</td>\n",
       "      <td>337.74</td>\n",
       "      <td>155.95</td>\n",
       "      <td>...</td>\n",
       "      <td>145.01</td>\n",
       "      <td>466.61</td>\n",
       "      <td>278.14</td>\n",
       "      <td>201.52</td>\n",
       "      <td>326.11</td>\n",
       "      <td>92.58</td>\n",
       "      <td>340.64</td>\n",
       "      <td>209.49</td>\n",
       "      <td>434.46</td>\n",
       "      <td>553.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City232</th>\n",
       "      <td>466.32</td>\n",
       "      <td>584.13</td>\n",
       "      <td>444.70</td>\n",
       "      <td>389.36</td>\n",
       "      <td>191.73</td>\n",
       "      <td>372.37</td>\n",
       "      <td>553.34</td>\n",
       "      <td>230.22</td>\n",
       "      <td>133.97</td>\n",
       "      <td>322.40</td>\n",
       "      <td>...</td>\n",
       "      <td>254.91</td>\n",
       "      <td>455.20</td>\n",
       "      <td>62.83</td>\n",
       "      <td>181.09</td>\n",
       "      <td>112.43</td>\n",
       "      <td>256.58</td>\n",
       "      <td>415.52</td>\n",
       "      <td>359.15</td>\n",
       "      <td>233.10</td>\n",
       "      <td>537.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City190</th>\n",
       "      <td>210.06</td>\n",
       "      <td>350.13</td>\n",
       "      <td>267.14</td>\n",
       "      <td>204.21</td>\n",
       "      <td>153.52</td>\n",
       "      <td>96.94</td>\n",
       "      <td>353.52</td>\n",
       "      <td>302.26</td>\n",
       "      <td>319.74</td>\n",
       "      <td>232.93</td>\n",
       "      <td>...</td>\n",
       "      <td>33.07</td>\n",
       "      <td>359.84</td>\n",
       "      <td>220.82</td>\n",
       "      <td>106.11</td>\n",
       "      <td>301.81</td>\n",
       "      <td>119.01</td>\n",
       "      <td>244.11</td>\n",
       "      <td>122.82</td>\n",
       "      <td>326.35</td>\n",
       "      <td>448.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City205</th>\n",
       "      <td>359.15</td>\n",
       "      <td>275.66</td>\n",
       "      <td>221.57</td>\n",
       "      <td>281.23</td>\n",
       "      <td>431.87</td>\n",
       "      <td>445.42</td>\n",
       "      <td>191.49</td>\n",
       "      <td>401.86</td>\n",
       "      <td>723.42</td>\n",
       "      <td>717.44</td>\n",
       "      <td>...</td>\n",
       "      <td>468.98</td>\n",
       "      <td>153.25</td>\n",
       "      <td>591.50</td>\n",
       "      <td>484.59</td>\n",
       "      <td>700.10</td>\n",
       "      <td>601.86</td>\n",
       "      <td>240.99</td>\n",
       "      <td>371.25</td>\n",
       "      <td>415.73</td>\n",
       "      <td>88.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City238</th>\n",
       "      <td>316.58</td>\n",
       "      <td>441.70</td>\n",
       "      <td>318.24</td>\n",
       "      <td>257.07</td>\n",
       "      <td>84.02</td>\n",
       "      <td>220.54</td>\n",
       "      <td>422.21</td>\n",
       "      <td>216.86</td>\n",
       "      <td>222.48</td>\n",
       "      <td>257.33</td>\n",
       "      <td>...</td>\n",
       "      <td>103.02</td>\n",
       "      <td>365.07</td>\n",
       "      <td>100.53</td>\n",
       "      <td>31.23</td>\n",
       "      <td>200.66</td>\n",
       "      <td>151.01</td>\n",
       "      <td>289.82</td>\n",
       "      <td>211.12</td>\n",
       "      <td>235.62</td>\n",
       "      <td>454.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City244</th>\n",
       "      <td>87.81</td>\n",
       "      <td>208.50</td>\n",
       "      <td>132.50</td>\n",
       "      <td>80.26</td>\n",
       "      <td>200.56</td>\n",
       "      <td>92.24</td>\n",
       "      <td>207.50</td>\n",
       "      <td>308.61</td>\n",
       "      <td>452.27</td>\n",
       "      <td>372.35</td>\n",
       "      <td>...</td>\n",
       "      <td>146.13</td>\n",
       "      <td>254.14</td>\n",
       "      <td>335.38</td>\n",
       "      <td>203.79</td>\n",
       "      <td>431.97</td>\n",
       "      <td>263.98</td>\n",
       "      <td>117.54</td>\n",
       "      <td>24.61</td>\n",
       "      <td>335.10</td>\n",
       "      <td>334.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City187</th>\n",
       "      <td>219.81</td>\n",
       "      <td>354.13</td>\n",
       "      <td>256.08</td>\n",
       "      <td>192.27</td>\n",
       "      <td>120.45</td>\n",
       "      <td>117.50</td>\n",
       "      <td>349.14</td>\n",
       "      <td>269.30</td>\n",
       "      <td>308.19</td>\n",
       "      <td>250.96</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>338.59</td>\n",
       "      <td>200.13</td>\n",
       "      <td>76.93</td>\n",
       "      <td>288.80</td>\n",
       "      <td>133.54</td>\n",
       "      <td>231.02</td>\n",
       "      <td>121.54</td>\n",
       "      <td>293.30</td>\n",
       "      <td>428.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City216</th>\n",
       "      <td>294.22</td>\n",
       "      <td>278.94</td>\n",
       "      <td>138.50</td>\n",
       "      <td>173.90</td>\n",
       "      <td>283.55</td>\n",
       "      <td>344.43</td>\n",
       "      <td>194.88</td>\n",
       "      <td>251.38</td>\n",
       "      <td>572.67</td>\n",
       "      <td>589.50</td>\n",
       "      <td>...</td>\n",
       "      <td>338.59</td>\n",
       "      <td>0.00</td>\n",
       "      <td>440.83</td>\n",
       "      <td>341.34</td>\n",
       "      <td>549.23</td>\n",
       "      <td>471.74</td>\n",
       "      <td>139.44</td>\n",
       "      <td>263.87</td>\n",
       "      <td>267.54</td>\n",
       "      <td>90.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City231</th>\n",
       "      <td>416.88</td>\n",
       "      <td>541.62</td>\n",
       "      <td>412.11</td>\n",
       "      <td>353.07</td>\n",
       "      <td>161.33</td>\n",
       "      <td>316.51</td>\n",
       "      <td>518.50</td>\n",
       "      <td>241.65</td>\n",
       "      <td>131.94</td>\n",
       "      <td>266.37</td>\n",
       "      <td>...</td>\n",
       "      <td>200.13</td>\n",
       "      <td>440.83</td>\n",
       "      <td>0.00</td>\n",
       "      <td>131.58</td>\n",
       "      <td>108.59</td>\n",
       "      <td>194.00</td>\n",
       "      <td>383.17</td>\n",
       "      <td>311.65</td>\n",
       "      <td>251.12</td>\n",
       "      <td>527.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City159</th>\n",
       "      <td>286.05</td>\n",
       "      <td>410.45</td>\n",
       "      <td>288.48</td>\n",
       "      <td>226.77</td>\n",
       "      <td>68.93</td>\n",
       "      <td>193.49</td>\n",
       "      <td>391.65</td>\n",
       "      <td>214.35</td>\n",
       "      <td>253.09</td>\n",
       "      <td>266.13</td>\n",
       "      <td>...</td>\n",
       "      <td>76.93</td>\n",
       "      <td>341.34</td>\n",
       "      <td>131.58</td>\n",
       "      <td>0.00</td>\n",
       "      <td>231.49</td>\n",
       "      <td>153.20</td>\n",
       "      <td>260.32</td>\n",
       "      <td>180.13</td>\n",
       "      <td>235.52</td>\n",
       "      <td>431.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City243</th>\n",
       "      <td>508.59</td>\n",
       "      <td>640.24</td>\n",
       "      <td>517.98</td>\n",
       "      <td>457.54</td>\n",
       "      <td>269.52</td>\n",
       "      <td>398.46</td>\n",
       "      <td>622.82</td>\n",
       "      <td>339.34</td>\n",
       "      <td>23.49</td>\n",
       "      <td>257.18</td>\n",
       "      <td>...</td>\n",
       "      <td>288.80</td>\n",
       "      <td>549.23</td>\n",
       "      <td>108.59</td>\n",
       "      <td>231.49</td>\n",
       "      <td>0.00</td>\n",
       "      <td>233.58</td>\n",
       "      <td>489.26</td>\n",
       "      <td>407.57</td>\n",
       "      <td>344.27</td>\n",
       "      <td>635.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City179</th>\n",
       "      <td>317.38</td>\n",
       "      <td>461.82</td>\n",
       "      <td>385.97</td>\n",
       "      <td>322.75</td>\n",
       "      <td>221.65</td>\n",
       "      <td>195.78</td>\n",
       "      <td>471.49</td>\n",
       "      <td>366.35</td>\n",
       "      <td>245.23</td>\n",
       "      <td>118.00</td>\n",
       "      <td>...</td>\n",
       "      <td>133.54</td>\n",
       "      <td>471.74</td>\n",
       "      <td>194.00</td>\n",
       "      <td>153.20</td>\n",
       "      <td>233.58</td>\n",
       "      <td>0.00</td>\n",
       "      <td>362.37</td>\n",
       "      <td>241.07</td>\n",
       "      <td>386.14</td>\n",
       "      <td>561.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City196</th>\n",
       "      <td>157.76</td>\n",
       "      <td>189.52</td>\n",
       "      <td>29.18</td>\n",
       "      <td>40.26</td>\n",
       "      <td>224.21</td>\n",
       "      <td>209.62</td>\n",
       "      <td>138.50</td>\n",
       "      <td>272.30</td>\n",
       "      <td>511.65</td>\n",
       "      <td>476.91</td>\n",
       "      <td>...</td>\n",
       "      <td>231.02</td>\n",
       "      <td>139.44</td>\n",
       "      <td>383.17</td>\n",
       "      <td>260.32</td>\n",
       "      <td>489.26</td>\n",
       "      <td>362.37</td>\n",
       "      <td>0.00</td>\n",
       "      <td>131.58</td>\n",
       "      <td>296.67</td>\n",
       "      <td>217.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City160</th>\n",
       "      <td>107.97</td>\n",
       "      <td>233.06</td>\n",
       "      <td>149.95</td>\n",
       "      <td>92.00</td>\n",
       "      <td>180.83</td>\n",
       "      <td>80.86</td>\n",
       "      <td>230.70</td>\n",
       "      <td>296.58</td>\n",
       "      <td>427.81</td>\n",
       "      <td>351.01</td>\n",
       "      <td>...</td>\n",
       "      <td>121.54</td>\n",
       "      <td>263.87</td>\n",
       "      <td>311.65</td>\n",
       "      <td>180.13</td>\n",
       "      <td>407.57</td>\n",
       "      <td>241.07</td>\n",
       "      <td>131.58</td>\n",
       "      <td>0.00</td>\n",
       "      <td>323.09</td>\n",
       "      <td>347.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City236</th>\n",
       "      <td>418.88</td>\n",
       "      <td>486.19</td>\n",
       "      <td>321.41</td>\n",
       "      <td>292.75</td>\n",
       "      <td>173.31</td>\n",
       "      <td>382.50</td>\n",
       "      <td>425.02</td>\n",
       "      <td>26.51</td>\n",
       "      <td>366.59</td>\n",
       "      <td>491.41</td>\n",
       "      <td>...</td>\n",
       "      <td>293.30</td>\n",
       "      <td>267.54</td>\n",
       "      <td>251.12</td>\n",
       "      <td>235.52</td>\n",
       "      <td>344.27</td>\n",
       "      <td>386.14</td>\n",
       "      <td>296.67</td>\n",
       "      <td>323.09</td>\n",
       "      <td>0.00</td>\n",
       "      <td>333.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>City227</th>\n",
       "      <td>361.50</td>\n",
       "      <td>312.30</td>\n",
       "      <td>207.70</td>\n",
       "      <td>255.49</td>\n",
       "      <td>372.19</td>\n",
       "      <td>426.66</td>\n",
       "      <td>223.14</td>\n",
       "      <td>322.16</td>\n",
       "      <td>658.70</td>\n",
       "      <td>679.22</td>\n",
       "      <td>...</td>\n",
       "      <td>428.24</td>\n",
       "      <td>90.26</td>\n",
       "      <td>527.30</td>\n",
       "      <td>431.26</td>\n",
       "      <td>635.23</td>\n",
       "      <td>561.57</td>\n",
       "      <td>217.31</td>\n",
       "      <td>347.28</td>\n",
       "      <td>333.78</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>26 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         City158  City223  City213  City212  City233  City174  City201  \\\n",
       "City158     0.00   145.84   156.19   136.34   288.14   121.87   180.37   \n",
       "City223   145.84     0.00   165.81   200.50   394.74   267.26    89.17   \n",
       "City213   156.19   165.81     0.00    63.84   253.38   224.34   109.58   \n",
       "City212   136.34   200.50    63.84     0.00   197.79   171.30   165.46   \n",
       "City233   288.14   394.74   253.38   197.79     0.00   220.80   361.66   \n",
       "City174   121.87   267.26   224.34   171.30   220.80     0.00   288.06   \n",
       "City201   180.37    89.17   109.58   165.46   361.66   288.06     0.00   \n",
       "City248   392.51   461.78   297.58   267.15   150.08   356.50   402.42   \n",
       "City234   527.73   660.70   540.29   479.52   292.61   416.00   644.67   \n",
       "City433   412.91   558.70   499.18   436.86   335.04   292.72   578.45   \n",
       "City181   258.08   403.60   359.28   300.56   261.47   140.59   428.66   \n",
       "City232   466.32   584.13   444.70   389.36   191.73   372.37   553.34   \n",
       "City190   210.06   350.13   267.14   204.21   153.52    96.94   353.52   \n",
       "City205   359.15   275.66   221.57   281.23   431.87   445.42   191.49   \n",
       "City238   316.58   441.70   318.24   257.07    84.02   220.54   422.21   \n",
       "City244    87.81   208.50   132.50    80.26   200.56    92.24   207.50   \n",
       "City187   219.81   354.13   256.08   192.27   120.45   117.50   349.14   \n",
       "City216   294.22   278.94   138.50   173.90   283.55   344.43   194.88   \n",
       "City231   416.88   541.62   412.11   353.07   161.33   316.51   518.50   \n",
       "City159   286.05   410.45   288.48   226.77    68.93   193.49   391.65   \n",
       "City243   508.59   640.24   517.98   457.54   269.52   398.46   622.82   \n",
       "City179   317.38   461.82   385.97   322.75   221.65   195.78   471.49   \n",
       "City196   157.76   189.52    29.18    40.26   224.21   209.62   138.50   \n",
       "City160   107.97   233.06   149.95    92.00   180.83    80.86   230.70   \n",
       "City236   418.88   486.19   321.41   292.75   173.31   382.50   425.02   \n",
       "City227   361.50   312.30   207.70   255.49   372.19   426.66   223.14   \n",
       "\n",
       "         City248  City234  City433  ...  City187  City216  City231  City159  \\\n",
       "City158   392.51   527.73   412.91  ...   219.81   294.22   416.88   286.05   \n",
       "City223   461.78   660.70   558.70  ...   354.13   278.94   541.62   410.45   \n",
       "City213   297.58   540.29   499.18  ...   256.08   138.50   412.11   288.48   \n",
       "City212   267.15   479.52   436.86  ...   192.27   173.90   353.07   226.77   \n",
       "City233   150.08   292.61   335.04  ...   120.45   283.55   161.33    68.93   \n",
       "City174   356.50   416.00   292.72  ...   117.50   344.43   316.51   193.49   \n",
       "City201   402.42   644.67   578.45  ...   349.14   194.88   518.50   391.65   \n",
       "City248     0.00   362.14   473.87  ...   269.30   251.38   241.65   214.35   \n",
       "City234   362.14     0.00   258.24  ...   308.19   572.67   131.94   253.09   \n",
       "City433   473.87   258.24     0.00  ...   250.96   589.50   266.37   266.13   \n",
       "City181   411.55   337.74   155.95  ...   145.01   466.61   278.14   201.52   \n",
       "City232   230.22   133.97   322.40  ...   254.91   455.20    62.83   181.09   \n",
       "City190   302.26   319.74   232.93  ...    33.07   359.84   220.82   106.11   \n",
       "City205   401.86   723.42   717.44  ...   468.98   153.25   591.50   484.59   \n",
       "City238   216.86   222.48   257.33  ...   103.02   365.07   100.53    31.23   \n",
       "City244   308.61   452.27   372.35  ...   146.13   254.14   335.38   203.79   \n",
       "City187   269.30   308.19   250.96  ...     0.00   338.59   200.13    76.93   \n",
       "City216   251.38   572.67   589.50  ...   338.59     0.00   440.83   341.34   \n",
       "City231   241.65   131.94   266.37  ...   200.13   440.83     0.00   131.58   \n",
       "City159   214.35   253.09   266.13  ...    76.93   341.34   131.58     0.00   \n",
       "City243   339.34    23.49   257.18  ...   288.80   549.23   108.59   231.49   \n",
       "City179   366.35   245.23   118.00  ...   133.54   471.74   194.00   153.20   \n",
       "City196   272.30   511.65   476.91  ...   231.02   139.44   383.17   260.32   \n",
       "City160   296.58   427.81   351.01  ...   121.54   263.87   311.65   180.13   \n",
       "City236    26.51   366.59   491.41  ...   293.30   267.54   251.12   235.52   \n",
       "City227   322.16   658.70   679.22  ...   428.24    90.26   527.30   431.26   \n",
       "\n",
       "         City243  City179  City196  City160  City236  City227  \n",
       "City158   508.59   317.38   157.76   107.97   418.88   361.50  \n",
       "City223   640.24   461.82   189.52   233.06   486.19   312.30  \n",
       "City213   517.98   385.97    29.18   149.95   321.41   207.70  \n",
       "City212   457.54   322.75    40.26    92.00   292.75   255.49  \n",
       "City233   269.52   221.65   224.21   180.83   173.31   372.19  \n",
       "City174   398.46   195.78   209.62    80.86   382.50   426.66  \n",
       "City201   622.82   471.49   138.50   230.70   425.02   223.14  \n",
       "City248   339.34   366.35   272.30   296.58    26.51   322.16  \n",
       "City234    23.49   245.23   511.65   427.81   366.59   658.70  \n",
       "City433   257.18   118.00   476.91   351.01   491.41   679.22  \n",
       "City181   326.11    92.58   340.64   209.49   434.46   553.44  \n",
       "City232   112.43   256.58   415.52   359.15   233.10   537.71  \n",
       "City190   301.81   119.01   244.11   122.82   326.35   448.61  \n",
       "City205   700.10   601.86   240.99   371.25   415.73    88.32  \n",
       "City238   200.66   151.01   289.82   211.12   235.62   454.46  \n",
       "City244   431.97   263.98   117.54    24.61   335.10   334.80  \n",
       "City187   288.80   133.54   231.02   121.54   293.30   428.24  \n",
       "City216   549.23   471.74   139.44   263.87   267.54    90.26  \n",
       "City231   108.59   194.00   383.17   311.65   251.12   527.30  \n",
       "City159   231.49   153.20   260.32   180.13   235.52   431.26  \n",
       "City243     0.00   233.58   489.26   407.57   344.27   635.23  \n",
       "City179   233.58     0.00   362.37   241.07   386.14   561.57  \n",
       "City196   489.26   362.37     0.00   131.58   296.67   217.31  \n",
       "City160   407.57   241.07   131.58     0.00   323.09   347.28  \n",
       "City236   344.27   386.14   296.67   323.09     0.00   333.78  \n",
       "City227   635.23   561.57   217.31   347.28   333.78     0.00  \n",
       "\n",
       "[26 rows x 26 columns]"
      ]
     },
     "execution_count": 145,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "selected_data_26"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Beijing': 'City1',\n",
       " 'Tianjin': 'City2',\n",
       " 'Shijiazhuang': 'City3',\n",
       " 'Tangshan': 'City9',\n",
       " 'Qinghuangdao': 'City12',\n",
       " 'Handan': 'City13',\n",
       " 'Xingtai': 'City15',\n",
       " 'Baoding': 'City18',\n",
       " 'Zhuangjiakou': 'City23',\n",
       " 'Chengde': 'City24',\n",
       " 'Cangzhou': 'City25',\n",
       " 'Langfang': 'City30',\n",
       " 'Hengshui': 'City33',\n",
       " 'Taiyuan': 'City36',\n",
       " 'Datong': 'City38',\n",
       " 'Yangquan': 'City39',\n",
       " 'changzhi': 'City40',\n",
       " 'Jincheng': 'City42',\n",
       " 'Shuozhou': 'City44',\n",
       " 'jinzhong': 'City45',\n",
       " 'Yuncheng': 'City47',\n",
       " 'Xinzhou': 'City50',\n",
       " 'Linfen': 'City52',\n",
       " 'lvliang': 'City55',\n",
       " 'Huhehaote': 'City56',\n",
       " 'Baotou': 'City57',\n",
       " 'Wuhai': 'City58',\n",
       " 'Chifeng': 'City59',\n",
       " 'Tongliao': 'City60',\n",
       " 'eerduosi': 'City62',\n",
       " 'hulunbeier': 'City63',\n",
       " 'bayannaoer': 'City69',\n",
       " 'wulanchabu': 'City70',\n",
       " 'Shenyang': 'City75',\n",
       " 'Dalian': 'City77',\n",
       " 'Anshan': 'City81',\n",
       " 'Fushun': 'City83',\n",
       " 'Benxi': 'City84',\n",
       " 'Dandong': 'City85',\n",
       " 'Jinzhou': 'City88',\n",
       " 'Yingkou': 'City90',\n",
       " 'Fuxin': 'City93',\n",
       " 'Liaoyao': 'City94',\n",
       " 'Panjing': 'City95',\n",
       " 'Tieling': 'City96',\n",
       " 'Huludao': 'City102',\n",
       " 'Changchun': 'City104',\n",
       " 'Jilin': 'City107',\n",
       " 'Siping': 'City111',\n",
       " 'Liaoyuan': 'City113',\n",
       " 'Tonghua': 'City114',\n",
       " 'Baishan': 'City117',\n",
       " 'Songyuan': 'City119',\n",
       " 'Baicheng': 'City120',\n",
       " 'Haerbin': 'City129',\n",
       " 'Qiqihaer': 'City134',\n",
       " 'Jixi': 'City136',\n",
       " 'Hegang': 'City138',\n",
       " 'Shuangyashan': 'City139',\n",
       " 'Daqing': 'City140',\n",
       " 'Yichun': 'City284',\n",
       " 'Jiamusi': 'City143',\n",
       " 'Qitaihe': 'City146',\n",
       " 'Mudanjiang': 'City147',\n",
       " 'Heihe': 'City151',\n",
       " 'Suihua': 'City154',\n",
       " 'Shanghai': 'City158',\n",
       " 'Nanjing': 'City159',\n",
       " 'Wuxi': 'City160',\n",
       " 'Xuzhou': 'City163',\n",
       " 'Changzhou': 'City166',\n",
       " 'Nantong': 'City174',\n",
       " 'huaian': 'City179',\n",
       " 'yancheng': 'City181',\n",
       " 'Yangzhou': 'City183',\n",
       " 'zhenjiang': 'City187',\n",
       " 'Taizhou': 'City224',\n",
       " 'Suqian': 'City195',\n",
       " 'Hangzhou': 'City196',\n",
       " 'ningbo': 'City201',\n",
       " 'Wenzhou': 'City205',\n",
       " 'Jiaxing': 'City208',\n",
       " 'Huzhou': 'City212',\n",
       " 'Shaoxing': 'City213',\n",
       " 'Jinhua': 'City216',\n",
       " 'Quzhou': 'City221',\n",
       " 'Zhoushan': 'City223',\n",
       " 'Lishui': 'City227',\n",
       " 'Hefei': 'City229',\n",
       " 'Wuhu': 'City230',\n",
       " 'Bengbu': 'City231',\n",
       " 'Huainan': 'City232',\n",
       " 'Maanshan': 'City233',\n",
       " 'Huaibei': 'City234',\n",
       " 'Tongling': 'City235',\n",
       " 'Anqing': 'City236',\n",
       " 'Huangshan': 'City237',\n",
       " 'Chuzhou': 'City238',\n",
       " 'Fuyang': 'City241',\n",
       " 'Suzhou': 'City243',\n",
       " 'suzhou': 'City244',\n",
       " 'liuan': 'City246',\n",
       " 'Bozhou': 'City247',\n",
       " 'chizou': 'City248',\n",
       " 'xuancheng': 'City249',\n",
       " 'Fuzhou': 'City250',\n",
       " 'Xiamen': 'City253',\n",
       " 'Futian': 'City254',\n",
       " 'sanming': 'City255',\n",
       " 'Quanzhou': 'City257',\n",
       " 'Zhangzhou': 'City261',\n",
       " 'Nanping': 'City263',\n",
       " 'Longyan': 'City268',\n",
       " 'Ningde': 'City270',\n",
       " 'Nanchang': 'City272',\n",
       " 'Jingdezheng': 'City273',\n",
       " 'chongzuo': 'City275',\n",
       " 'Jiujiang': 'City276',\n",
       " 'Xinyu': 'City278',\n",
       " 'Yingtan': 'City279',\n",
       " 'Ganzhou': 'City280',\n",
       " 'Jian': 'City282',\n",
       " 'fuzhou': 'City288',\n",
       " 'Shangrao': 'City289',\n",
       " 'Jinan': 'City291',\n",
       " 'Qingdao': 'City293',\n",
       " 'Zibo': 'City299',\n",
       " 'Zaozhuang': 'City300',\n",
       " 'Dongying': 'City302',\n",
       " 'Yantai': 'City303',\n",
       " 'Weifang': 'City309',\n",
       " 'Qinzhou': 'City310',\n",
       " 'Jining': 'City316',\n",
       " 'Taian': 'City320',\n",
       " 'Weihai': 'City323',\n",
       " 'Rizhao': 'City327',\n",
       " 'Laiwu': 'City328',\n",
       " 'Linyi': 'City329',\n",
       " 'Dezhou': 'City330',\n",
       " 'Liaocheng': 'City333',\n",
       " 'Binzhou': 'City335',\n",
       " 'heze': 'City336',\n",
       " 'Zhengzhou': 'City337',\n",
       " 'Kaifeng': 'City343',\n",
       " 'Luoyang': 'City344',\n",
       " 'Pingdingshan': 'City346',\n",
       " 'Anyang': 'City349',\n",
       " 'Hebi': 'City351',\n",
       " 'Xinxiang': 'City352',\n",
       " 'Jiaozuo': 'City355',\n",
       " 'Puyang': 'City358',\n",
       " 'Xuchang': 'City359',\n",
       " 'Luohe': 'City362',\n",
       " 'sanmenxia': 'City363',\n",
       " 'Nanyang': 'City366',\n",
       " 'Shangqiu': 'City368',\n",
       " 'Xinyang': 'City369',\n",
       " 'Zhoukou': 'City370',\n",
       " 'Zhumadian': 'City372',\n",
       " 'Wuhan': 'City373',\n",
       " 'Huangshi': 'City374',\n",
       " 'Shiyan': 'City376',\n",
       " 'Yichang': 'City378',\n",
       " 'Xiangfan': 'City380',\n",
       " 'Ezhou': 'City384',\n",
       " 'Jingmen': 'City385',\n",
       " 'Xiaogan': 'City387',\n",
       " 'jingzhou': 'City390',\n",
       " 'huanggang': 'City393',\n",
       " 'xianning': 'City396',\n",
       " 'Suizhou': 'City398',\n",
       " 'Changsha': 'City405',\n",
       " 'Zhuzhou': 'City407',\n",
       " 'Xiangtan': 'City409',\n",
       " 'Hengyang': 'City412',\n",
       " 'Shaoyang': 'City414',\n",
       " 'Yueyang': 'City416',\n",
       " 'Changde': 'City419',\n",
       " 'zhangjiajie': 'City421',\n",
       " 'Yiyang': 'City422',\n",
       " 'chenzhou': 'City424',\n",
       " 'Yongzhou': 'City426',\n",
       " 'Huaihua': 'City428',\n",
       " 'Loudi': 'City430',\n",
       " 'Lianyungang': 'City433',\n",
       " 'Guangzhou': 'City435',\n",
       " 'Shaoguan': 'City440',\n",
       " 'Shenzhen': 'City442',\n",
       " 'Zhuhai': 'City443',\n",
       " 'Shantou': 'City444',\n",
       " 'Foshan': 'City447',\n",
       " 'Jiangmen': 'City452',\n",
       " 'Zhanjiang': 'City458',\n",
       " 'Maoming': 'City462',\n",
       " 'Zhaoqing': 'City465',\n",
       " 'Meizhou': 'City470',\n",
       " 'Shanwei': 'City472',\n",
       " 'Heyuan': 'City473',\n",
       " 'Yangjiang': 'City474',\n",
       " 'Qingyuan': 'City476',\n",
       " 'Dongguan': 'City479',\n",
       " 'Zhongshan': 'City480',\n",
       " 'Chaozhou': 'City481',\n",
       " 'Jieyang': 'City482',\n",
       " 'Yunfu': 'City484',\n",
       " 'Naning': 'City486',\n",
       " 'Liuzhou': 'City487',\n",
       " 'Guilin': 'City488',\n",
       " 'Wuzhou': 'City489',\n",
       " 'Beihai': 'City490',\n",
       " 'Fangchenggang': 'City491',\n",
       " 'Guigang': 'City493',\n",
       " 'Yulin': 'City581',\n",
       " 'Baise': 'City497',\n",
       " 'Hechi': 'City498',\n",
       " 'laibin': 'City500',\n",
       " 'Pingxiang': 'City501',\n",
       " 'Haikou': 'City502',\n",
       " 'sanya': 'City504',\n",
       " 'Chongqing': 'City508',\n",
       " 'Chengdu': 'City515',\n",
       " 'Zigong': 'City520',\n",
       " 'Panzhihua': 'City521',\n",
       " 'Luzhou': 'City522',\n",
       " 'Deyang': 'City523',\n",
       " 'mianyang': 'City525',\n",
       " 'Guangyuan': 'City527',\n",
       " 'Suining': 'City528',\n",
       " 'Neijiang': 'City529',\n",
       " 'Leshan': 'City530',\n",
       " 'meishan': 'City531',\n",
       " 'Nanchong': 'City532',\n",
       " 'Yibin': 'City534',\n",
       " 'guangan': 'City535',\n",
       " 'dazhou': 'City536',\n",
       " 'Yaan': 'City538',\n",
       " 'Bazhong': 'City539',\n",
       " 'Ziyang': 'City540',\n",
       " 'Guiyang': 'City543',\n",
       " 'Liupanshui': 'City545',\n",
       " 'zunyi': 'City546',\n",
       " 'Anshun': 'City548',\n",
       " 'Tongren': 'City549',\n",
       " 'Bijie': 'City551',\n",
       " 'Kunming': 'City554',\n",
       " 'Qujing': 'City556',\n",
       " 'Yuxi': 'City558',\n",
       " 'Baoshan': 'City559',\n",
       " 'Zhaotong': 'City560',\n",
       " 'Lasa': 'City569',\n",
       " 'Xian': 'City571',\n",
       " 'Tongchuan': 'City572',\n",
       " 'Baoji': 'City573',\n",
       " 'Xianyang': 'City574',\n",
       " 'Weinan': 'City576',\n",
       " 'Yanan': 'City579',\n",
       " 'Hanzhong': 'City580',\n",
       " 'Ankang': 'City582',\n",
       " 'shangluo': 'City583',\n",
       " 'Lanzhou': 'City584',\n",
       " 'Jiayuguan': 'City585',\n",
       " 'Jinchang': 'City586',\n",
       " 'Baiyin': 'City587',\n",
       " 'Tianshui': 'City588',\n",
       " 'Wuwei': 'City589',\n",
       " 'Zhangye': 'City590',\n",
       " 'Pingliang': 'City591',\n",
       " 'Jiuquan': 'City592',\n",
       " 'qingyang': 'City595',\n",
       " 'Xining': 'City597',\n",
       " 'Yinchuan': 'City600',\n",
       " 'Shizuishan': 'City601',\n",
       " 'Wuzhong': 'City602',\n",
       " 'Wulumuqi': 'City604',\n",
       " 'Kelamayi': 'City605'}"
      ]
     },
     "execution_count": 148,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "city_to_city_series"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 150,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'City1': 'Beijing',\n",
       " 'City2': 'Tianjin',\n",
       " 'City3': 'Shijiazhuang',\n",
       " 'City9': 'Tangshan',\n",
       " 'City12': 'Qinghuangdao',\n",
       " 'City13': 'Handan',\n",
       " 'City15': 'Xingtai',\n",
       " 'City18': 'Baoding',\n",
       " 'City23': 'Zhuangjiakou',\n",
       " 'City24': 'Chengde',\n",
       " 'City25': 'Cangzhou',\n",
       " 'City30': 'Langfang',\n",
       " 'City33': 'Hengshui',\n",
       " 'City36': 'Taiyuan',\n",
       " 'City38': 'Datong',\n",
       " 'City39': 'Yangquan',\n",
       " 'City40': 'changzhi',\n",
       " 'City42': 'Jincheng',\n",
       " 'City44': 'Shuozhou',\n",
       " 'City45': 'jinzhong',\n",
       " 'City47': 'Yuncheng',\n",
       " 'City50': 'Xinzhou',\n",
       " 'City52': 'Linfen',\n",
       " 'City55': 'lvliang',\n",
       " 'City56': 'Huhehaote',\n",
       " 'City57': 'Baotou',\n",
       " 'City58': 'Wuhai',\n",
       " 'City59': 'Chifeng',\n",
       " 'City60': 'Tongliao',\n",
       " 'City62': 'eerduosi',\n",
       " 'City63': 'hulunbeier',\n",
       " 'City69': 'bayannaoer',\n",
       " 'City70': 'wulanchabu',\n",
       " 'City75': 'Shenyang',\n",
       " 'City77': 'Dalian',\n",
       " 'City81': 'Anshan',\n",
       " 'City83': 'Fushun',\n",
       " 'City84': 'Benxi',\n",
       " 'City85': 'Dandong',\n",
       " 'City88': 'Jinzhou',\n",
       " 'City90': 'Yingkou',\n",
       " 'City93': 'Fuxin',\n",
       " 'City94': 'Liaoyao',\n",
       " 'City95': 'Panjing',\n",
       " 'City96': 'Tieling',\n",
       " 'City102': 'Huludao',\n",
       " 'City104': 'Changchun',\n",
       " 'City107': 'Jilin',\n",
       " 'City111': 'Siping',\n",
       " 'City113': 'Liaoyuan',\n",
       " 'City114': 'Tonghua',\n",
       " 'City117': 'Baishan',\n",
       " 'City119': 'Songyuan',\n",
       " 'City120': 'Baicheng',\n",
       " 'City129': 'Haerbin',\n",
       " 'City134': 'Qiqihaer',\n",
       " 'City136': 'Jixi',\n",
       " 'City138': 'Hegang',\n",
       " 'City139': 'Shuangyashan',\n",
       " 'City140': 'Daqing',\n",
       " 'City141': 'Yichun',\n",
       " 'City143': 'Jiamusi',\n",
       " 'City146': 'Qitaihe',\n",
       " 'City147': 'Mudanjiang',\n",
       " 'City151': 'Heihe',\n",
       " 'City154': 'Suihua',\n",
       " 'City158': 'Shanghai',\n",
       " 'City159': 'Nanjing',\n",
       " 'City160': 'Wuxi',\n",
       " 'City163': 'Xuzhou',\n",
       " 'City166': 'Changzhou',\n",
       " 'City174': 'Nantong',\n",
       " 'City179': 'huaian',\n",
       " 'City181': 'yancheng',\n",
       " 'City183': 'Yangzhou',\n",
       " 'City187': 'zhenjiang',\n",
       " 'City190': 'Taizhou',\n",
       " 'City195': 'Suqian',\n",
       " 'City196': 'Hangzhou',\n",
       " 'City201': 'ningbo',\n",
       " 'City205': 'Wenzhou',\n",
       " 'City208': 'Jiaxing',\n",
       " 'City212': 'Huzhou',\n",
       " 'City213': 'Shaoxing',\n",
       " 'City216': 'Jinhua',\n",
       " 'City221': 'Quzhou',\n",
       " 'City223': 'Zhoushan',\n",
       " 'City224': 'Taizhou',\n",
       " 'City227': 'Lishui',\n",
       " 'City229': 'Hefei',\n",
       " 'City230': 'Wuhu',\n",
       " 'City231': 'Bengbu',\n",
       " 'City232': 'Huainan',\n",
       " 'City233': 'Maanshan',\n",
       " 'City234': 'Huaibei',\n",
       " 'City235': 'Tongling',\n",
       " 'City236': 'Anqing',\n",
       " 'City237': 'Huangshan',\n",
       " 'City238': 'Chuzhou',\n",
       " 'City241': 'Fuyang',\n",
       " 'City243': 'Suzhou',\n",
       " 'City244': 'suzhou',\n",
       " 'City246': 'liuan',\n",
       " 'City247': 'Bozhou',\n",
       " 'City248': 'chizou',\n",
       " 'City249': 'xuancheng',\n",
       " 'City250': 'Fuzhou',\n",
       " 'City253': 'Xiamen',\n",
       " 'City254': 'Futian',\n",
       " 'City255': 'sanming',\n",
       " 'City257': 'Quanzhou',\n",
       " 'City261': 'Zhangzhou',\n",
       " 'City263': 'Nanping',\n",
       " 'City268': 'Longyan',\n",
       " 'City270': 'Ningde',\n",
       " 'City272': 'Nanchang',\n",
       " 'City273': 'Jingdezheng',\n",
       " 'City275': 'chongzuo',\n",
       " 'City276': 'Jiujiang',\n",
       " 'City278': 'Xinyu',\n",
       " 'City279': 'Yingtan',\n",
       " 'City280': 'Ganzhou',\n",
       " 'City282': 'Jian',\n",
       " 'City284': 'Yichun',\n",
       " 'City288': 'fuzhou',\n",
       " 'City289': 'Shangrao',\n",
       " 'City291': 'Jinan',\n",
       " 'City293': 'Qingdao',\n",
       " 'City299': 'Zibo',\n",
       " 'City300': 'Zaozhuang',\n",
       " 'City302': 'Dongying',\n",
       " 'City303': 'Yantai',\n",
       " 'City309': 'Weifang',\n",
       " 'City310': 'Qinzhou',\n",
       " 'City316': 'Jining',\n",
       " 'City320': 'Taian',\n",
       " 'City323': 'Weihai',\n",
       " 'City327': 'Rizhao',\n",
       " 'City328': 'Laiwu',\n",
       " 'City329': 'Linyi',\n",
       " 'City330': 'Dezhou',\n",
       " 'City333': 'Liaocheng',\n",
       " 'City335': 'Binzhou',\n",
       " 'City336': 'heze',\n",
       " 'City337': 'Zhengzhou',\n",
       " 'City343': 'Kaifeng',\n",
       " 'City344': 'Luoyang',\n",
       " 'City346': 'Pingdingshan',\n",
       " 'City349': 'Anyang',\n",
       " 'City351': 'Hebi',\n",
       " 'City352': 'Xinxiang',\n",
       " 'City355': 'Jiaozuo',\n",
       " 'City358': 'Puyang',\n",
       " 'City359': 'Xuchang',\n",
       " 'City362': 'Luohe',\n",
       " 'City363': 'sanmenxia',\n",
       " 'City366': 'Nanyang',\n",
       " 'City368': 'Shangqiu',\n",
       " 'City369': 'Xinyang',\n",
       " 'City370': 'Zhoukou',\n",
       " 'City372': 'Zhumadian',\n",
       " 'City373': 'Wuhan',\n",
       " 'City374': 'Huangshi',\n",
       " 'City376': 'Shiyan',\n",
       " 'City378': 'Yichang',\n",
       " 'City380': 'Xiangfan',\n",
       " 'City384': 'Ezhou',\n",
       " 'City385': 'Jingmen',\n",
       " 'City387': 'Xiaogan',\n",
       " 'City390': 'jingzhou',\n",
       " 'City393': 'huanggang',\n",
       " 'City396': 'xianning',\n",
       " 'City398': 'Suizhou',\n",
       " 'City405': 'Changsha',\n",
       " 'City407': 'Zhuzhou',\n",
       " 'City409': 'Xiangtan',\n",
       " 'City412': 'Hengyang',\n",
       " 'City414': 'Shaoyang',\n",
       " 'City416': 'Yueyang',\n",
       " 'City419': 'Changde',\n",
       " 'City421': 'zhangjiajie',\n",
       " 'City422': 'Yiyang',\n",
       " 'City424': 'chenzhou',\n",
       " 'City426': 'Yongzhou',\n",
       " 'City428': 'Huaihua',\n",
       " 'City430': 'Loudi',\n",
       " 'City433': 'Lianyungang',\n",
       " 'City435': 'Guangzhou',\n",
       " 'City440': 'Shaoguan',\n",
       " 'City442': 'Shenzhen',\n",
       " 'City443': 'Zhuhai',\n",
       " 'City444': 'Shantou',\n",
       " 'City447': 'Foshan',\n",
       " 'City452': 'Jiangmen',\n",
       " 'City458': 'Zhanjiang',\n",
       " 'City462': 'Maoming',\n",
       " 'City465': 'Zhaoqing',\n",
       " 'City470': 'Meizhou',\n",
       " 'City472': 'Shanwei',\n",
       " 'City473': 'Heyuan',\n",
       " 'City474': 'Yangjiang',\n",
       " 'City476': 'Qingyuan',\n",
       " 'City479': 'Dongguan',\n",
       " 'City480': 'Zhongshan',\n",
       " 'City481': 'Chaozhou',\n",
       " 'City482': 'Jieyang',\n",
       " 'City484': 'Yunfu',\n",
       " 'City486': 'Naning',\n",
       " 'City487': 'Liuzhou',\n",
       " 'City488': 'Guilin',\n",
       " 'City489': 'Wuzhou',\n",
       " 'City490': 'Beihai',\n",
       " 'City491': 'Fangchenggang',\n",
       " 'City493': 'Guigang',\n",
       " 'City495': 'Yulin',\n",
       " 'City497': 'Baise',\n",
       " 'City498': 'Hechi',\n",
       " 'City500': 'laibin',\n",
       " 'City501': 'Pingxiang',\n",
       " 'City502': 'Haikou',\n",
       " 'City504': 'sanya',\n",
       " 'City508': 'Chongqing',\n",
       " 'City515': 'Chengdu',\n",
       " 'City520': 'Zigong',\n",
       " 'City521': 'Panzhihua',\n",
       " 'City522': 'Luzhou',\n",
       " 'City523': 'Deyang',\n",
       " 'City525': 'mianyang',\n",
       " 'City527': 'Guangyuan',\n",
       " 'City528': 'Suining',\n",
       " 'City529': 'Neijiang',\n",
       " 'City530': 'Leshan',\n",
       " 'City531': 'meishan',\n",
       " 'City532': 'Nanchong',\n",
       " 'City534': 'Yibin',\n",
       " 'City535': 'guangan',\n",
       " 'City536': 'dazhou',\n",
       " 'City538': 'Yaan',\n",
       " 'City539': 'Bazhong',\n",
       " 'City540': 'Ziyang',\n",
       " 'City543': 'Guiyang',\n",
       " 'City545': 'Liupanshui',\n",
       " 'City546': 'zunyi',\n",
       " 'City548': 'Anshun',\n",
       " 'City549': 'Tongren',\n",
       " 'City551': 'Bijie',\n",
       " 'City554': 'Kunming',\n",
       " 'City556': 'Qujing',\n",
       " 'City558': 'Yuxi',\n",
       " 'City559': 'Baoshan',\n",
       " 'City560': 'Zhaotong',\n",
       " 'City569': 'Lasa',\n",
       " 'City571': 'Xian',\n",
       " 'City572': 'Tongchuan',\n",
       " 'City573': 'Baoji',\n",
       " 'City574': 'Xianyang',\n",
       " 'City576': 'Weinan',\n",
       " 'City579': 'Yanan',\n",
       " 'City580': 'Hanzhong',\n",
       " 'City581': 'Yulin',\n",
       " 'City582': 'Ankang',\n",
       " 'City583': 'shangluo',\n",
       " 'City584': 'Lanzhou',\n",
       " 'City585': 'Jiayuguan',\n",
       " 'City586': 'Jinchang',\n",
       " 'City587': 'Baiyin',\n",
       " 'City588': 'Tianshui',\n",
       " 'City589': 'Wuwei',\n",
       " 'City590': 'Zhangye',\n",
       " 'City591': 'Pingliang',\n",
       " 'City592': 'Jiuquan',\n",
       " 'City595': 'qingyang',\n",
       " 'City597': 'Xining',\n",
       " 'City600': 'Yinchuan',\n",
       " 'City601': 'Shizuishan',\n",
       " 'City602': 'Wuzhong',\n",
       " 'City604': 'Wulumuqi',\n",
       " 'City605': 'Kelamayi'}"
      ]
     },
     "execution_count": 150,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "city_series_to_city"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 153,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['City158', 'City223', 'City213', 'City212', 'City233', 'City174',\n",
       "       'City201', 'City248', 'City234', 'City433', 'City181', 'City232',\n",
       "       'City190', 'City205', 'City238', 'City244', 'City187', 'City216',\n",
       "       'City231', 'City159', 'City243', 'City179', 'City196', 'City160',\n",
       "       'City236', 'City227'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 153,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "# city_series_26_columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 155,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Shanghai', 'Zhoushan', 'Shaoxing', 'Huzhou', 'Maanshan', 'Nantong', 'ningbo', 'chizou', 'Huaibei', 'Lianyungang', 'yancheng', 'Huainan', 'Taizhou', 'Wenzhou', 'Chuzhou', 'suzhou', 'zhenjiang', 'Jinhua', 'Bengbu', 'Nanjing', 'Suzhou', 'huaian', 'Hangzhou', 'Wuxi', 'Anqing', 'Lishui']\n"
     ]
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# city_26"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
